home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Grab Bag
/
Shareware Grab Bag.iso
/
090
/
kwmacros.arc
/
123.KW
next >
Wrap
Text File
|
1986-03-13
|
5KB
|
132 lines
{{F10}<Calculation>{Menu}{1,61}{IdOff}
{Select}{31,32,33,34,53,54,35}{Menu}
{{31}<Sum>@sum({100}.{101}){Enter}
{{32}<Count>@count({100}.{101}){Enter}
{{33}<Average>@avg({100}.{101}){Enter}
{{34}<Maximum>@max({100}.{101}){Enter}
{{100}<msg1>{Text}{24,1,1,80}Move cursor to
beginning of range, then press Return\{Text}{Pause}{Restore}
{{101}<msg2>{Text}{24,1,1,80}Move cursor to
end of range, then press Return\{Text}{Pause}{Restore}
{{53}<Horizontal Lookup>@hlookup({120},{121}.{122},{124}){Enter}
{{54}<Vertical Lookup>@vlookup({120},{121}.{122},{123}){Enter}
{{120}<msg1>{Text}{24,1,1,80}Move cursor to
cell to be looked up, then press Return\{Text}{Pause}{Restore}
{{121}<msg1>{Text}{24,1,1,80}Move cursor to
top left corner of lookup table, then press Return\{Text}{Pause}
{Restore}
{{122}<msg1>{Text}{24,1,1,80}Move cursor to
bottom right corner of lookup table, then press Return\{Text}
{Pause}{Restore}
{{123}<msg1>{Text}{24,1,1,80}Enter column f
rom which answer is to be returned (0 - 9), then press Retu
rn\{Text}{FixPause}{1}{Restore}
{{124}<msg1>{Text}{24,1,1,80}Enter row from
which answer is to be returned (0 - 9), then press Return\
{Text}{FixPause}{1}{Restore}
{{35}<Function F10>{pass}{f10}
{{F9}<Swap>{Menu}{1,65}{IdOff}{36,37,38}{Menu}
{{36}<Row swap>{102}/rncrow1{Enter}.{104}{Enter}/w
ir{Enter}/mrow1{Enter}{Enter}{103}/rncrow2{Enter}.{104}{Enter}
{Pass}{F5}row1{Enter}{Dn}/crow2{Enter}{Enter}{Pass}{F5}row2
{Enter}/crow1{Enter}{Enter}{Pass}{F5}row1{Enter}/wdr{Enter}
/rndrow1{Enter}/rndrow2{Enter}
{{102}<text1>{Text}{24,1,1,80}Move cursor to
beginning of first row to be swapped, then press Return\{Text}
{Pause}{Restore}
{{103}<text2>{Text}{24,1,1,80}Move cursor to
beginning of second row to be swapped, then press Return\{Text}
{Pause}{Restore}
{{104}<text3>{Text}{24,1,1,80}Move cursor to
end of row, then press Return\{Text}{Pause}{Restore}
{{37}<Column Swap>{105}/rnccol1{Enter}.{107}{Enter}/w
ic{Enter}/mcol1{Enter}{Enter}{106}/rnccol2{Enter}.{107}{Enter}
{Pass}{F5}col1{Enter}{Rght}/ccol2{Enter}{Enter}{Pass}{F5}co
l2{Enter}/ccol1{Enter}{Enter}{Pass}{F5}col1{Enter}/wdc{Enter}
/rndcol1{Enter}/rndcol2{Enter}
{{105}<text1>{Text}{24,1,1,80}Move cursor to
top of first column to be swapped, then press Return\{Text}
{Pause}{Restore}
{{106}<text2>{Text}{24,1,1,80}Move cursor to
top of second column to be swapped, then press Return\{Text}
{Pause}{Restore}
{{107}<text3>{Text}{24,1,1,80}Move cursor to
end of column, then press Return\{Text}{Pause}{Restore}
{{38}<Function F9>{pass}{f9}
{{F7}<Titles>{Menu}{1,65}{IdOff}{Select}{39,40,41,42,43}{Menu}
{{39}<Horizontal>/wth
{{40}<Vertical>/wtv
{{41}<Both>/wtb
{{42}<Clear>/wtc
{{43}<Function F7>{pass}{f7}
{{F8}<Windows>{Menu}{1,65}{IdOff}{Select}{44,45,46,47,48}{Menu}
{{44}<Horizontal>/wwh
{{45}<Vertical>/wwv
{{46}<Clear>/wwc
{{47}<Switch>{Pass}{F6}
{{48}<Function F8>{pass}{f8}
{{`}<Formula builder>{52}
{{49}<>@{Define}{52}<>{50}{Define}
{{50}<>({Define}{52}<>{51}{Define}
{{51}<>){Define}{52}<>{49}{Define}
{{52}<>{49}
{{F1}<Macro builder>{Menu}{1,60}{IdOff}{55,56,57}{Menu}
{{55}<Define keys>
{Define}{Home}{PassTxt}{Home}{PassTxt}{Define}
{Define}{End}{PassTxt}{End}{PassTxt}{Define}
{Define}{Up}{PassTxt}{Up}{PassTxt}{Define}
{Define}{Dn}{Down}{Define}
{Define}{Lft}{Left}{Define}
{Define}{Rght}{Right}{Define}
{Define}{PgUp}{PassTxt}{PgUp}{PassTxt}{Define}
{Define}{PgDn}{PassTxt}{PgDn}{PassTxt}{Define}
{Define}{Enter}~{Define}
{Define}{Esc}{PassTxt}{Esc}{PassTxt}{Define}
{Define}{BkSp}{Bs}{Define}
{Define}{F2}{Edit}{Define}
{Define}{F3}{Name}{Define}
{Define}{F4}{Abs}{Define}
{Define}{F5}{PassTxt}{GoTo}{PassTxt}{Define}
{Define}{F6}{Window}{Define}
{Define}{F7}{Query}{Define}
{Define}{F8}{Table}{Define}
{Define}{F9}{Calc}{Define}
{Define}{F10}{Graph}{Define}
{{56}<Undefine keys>
{Define}{Home}{Pass}{Home}{Define}
{Define}{End}{Pass}{End}{Define}
{Define}{Up}{Pass}{Up}{Define}
{Define}{Dn}{Pass}{Dn}{Define}
{Define}{Lft}{Pass}{Lft}{Define}
{Define}{Rght}{Pass}{Rght}{Define}
{Define}{PgUp}{Pass}{PgUp}{Define}
{Define}{PgDn}{Pass}{PgDn}{Define}
{Define}{Enter}{Pass}{Enter}{Define}
{Define}{Esc}{Pass}{Esc}{Define}
{Define}{BkSp}{Pass}{BkSp}{Define}
{Define}{F2}{Pass}{F2}{Define}
{Define}{F3}{Pass}{F3}{Define}
{Define}{F4}{Pass}{F4}{Define}
{Define}{F5}{Pass}{F5}{Define}
{Define}{F6}{Pass}{F6}{Define}
{Define}{F7}<Titles>{Menu}{1,65}{IdOff}{Select}{39,40,41,42,43}{Menu}{Define}
{Define}{F8}<Windows>{Menu}{1,65}{IdOff}{Select}{44,45,46,47,48}{Menu}{Define}
{Define}{F9}<Swap>{Menu}{1,65}{IdOff}{36,37,38}{Menu}{Define}
{Define}{F10}<Calculation>{Menu}{1,61}{IdOff}
{Select}{31,32,33,34,53,54,35}{Menu}
{Define}
{{57}<Help>{pass}{F1}